Practical Module:-
- TCS (TAX COLLECTION AT SOURCE)
- SERVICE TAX
- JOB WORK accounting IN TALLY.ERP9
Module 3
E-Filing:-- VAT FORM
VAT FORM - Dvat20 , Dvat 16 , Dvat 01 , Dvat 01-Annexure I , Dvat 01-Annexure II ,
Dvat 01-Annexure III , Dvat13 , Dvat 17 , Dvat 32 , Dvat 04 ,
Dvat 04-Annexure-I , Dvat 04-Annexure-II , Dvat 04-Annexure-III ,
Dvat 04A , Dvat 04A-Annexure-I , Dvat 04A-Annexure-II ,
Dvat 12 , Dvat 16(Q) , Dvat 16(M) , Dvat 21A ,
Dvat16(A) Dvat16(H) , Dvat16(H) TDS FORM - TDS/TCS Challan,
TDS 24Q ,TDS 26Q Service tax return - ST-3
INCOME TAX RETURN FORM - ITR-1 , ITR-2 , ITR-3 , ITR-4 , ITR-5
Module-Advance Exel:
WORKING WITH LISTS:-
Sorting Records in a List,
Using AutoFilter in a List,
Creating a Chart with the 2D or 3D,
Paretos Charts, Web Page Preview,
Converting Worksheets into Web
Pages Inserting Hyperlinks,
Viewing & Editing Comments,
Using Conditional Formatting,
Format As table, Create our Styles,
Using the HLOOKUP Function,
Using the VLOOKUP Function,
Creating a Macro, Running a Macro,
Adding Subtotals to a List,
Nesting Subtotals, Applying
Advance Filters, Data Validation,
|
Locking/Unlocking Cells in a worksheet,
Protecting a Worksheet,
Protecting a Workbook,
Creating a Shared Workbook,
Tracking Changes to a Workbook
- Formulas:-
Sum,Product,Average,
IF,Days360,Date,Ceiling,
Floor,Round, Round up,
Round down, Power, Count,
Count A, Count If, Sum if,
Minimum, Maximum, Hookup for
single worksheet,
Vlookup for single worksheet,
Hlookup & Vlookup for multiple Sheet,
Index, Show formula , Or, Not ,Iferr ,
Lookup, Rate, Ppmt, Ipmt ,Networkdays,
Roundup,Rounddown,Mode, Media,Received ,
Log,Dollar,AverageA, Averageif,Averageifs,
Mina ,Maxa,Sumifs, Large,Pv,Fv,
Coupdays,Coupnum, Datedif,Daverage,
Dproduct,Indirect, Rank,Rank Between ,
WorkDays, Transpose, Mod with Conditional
, Find ,Mid, Iserror, Iserr, Iferror, offset,
Nesting Lookup Function, Rank Average,
Choose With Vlookup, Dash Board by
Picking List, Dmin, Dmax, Dcount ,
Dsum ,Dget, Now, Today, Weekdays,
SQRT, Mod, Upper, Lower, Left,
Right, Exact,
Len, Match, Roman ,
Proper, Pmt ,Concatenate,
IF Function & Nested IF Statements
And & Or Functions
- Statements:-
MIS Report (Profit & Loss a/c Statement,
Balance sheet, Worker contribution statement,
Cash flow statement, Debtor’s
& Creditors statement, Inventory Statement,
BRS Statement, Fixed Assets &
fund statement, Payroll Report, P.F & E.S.I Report
|